﻿-- 创建网站订单
CREATE proc [dbo].[proc_SiteForm_Create]
(
	@CompanyId nvarchar(50),
	@CustomerId nvarchar (50),
	@CustomerName nvarchar (50),
	@OrderId nvarchar (50),
	@ProductId int,
	@ContactPerson nvarchar (50),
	@ContactTel nvarchar (50),
	@SignDate datetime,
	@CreateDate datetime,
	@WebSitePrice decimal,
	@Description text
)
as
	insert into siteform
	(			
		CompanyId,CustomerId,CustomerName,OrderId,ProductId,ContactPerson,ContactTel,SignDate,CreateTime,WebSitePrice,
		[Description]
	)
	values
	(
		@CompanyId,@CustomerId,@CustomerName,@OrderId,@ProductId,@ContactPerson,@ContactTel,@SignDate,getdate
		(),@WebSitePrice,@Description
	)